﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ExcelLoad.aspx.cs" Inherits="WEALTH.Manager.Customer.ExcelLoad" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <link href="../css/base.css" rel="Stylesheet" type="text/css" />
    <script type="text/javascript" src="../Js/jquery.min.js"></script>
    <script type="text/javascript" src="../Js/vanadium.js"></script>
    <script type="text/javascript" src="../Js/public_Validation.js"></script>
    <link href="../css/admin.global.css" rel="stylesheet" type="text/css" />
    <link href="../css/admin.content.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="../js/jquery-1.4.2.min.js"></script>
    <script type="text/javascript" src="../js/jquery.utils.js"></script>
    <link href="../jBox/Skins/Green/jbox.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="../jBox/jquery.jBox-2.3.min.js"></script>
    <script type="text/javascript" src="../js/admin.js"></script>
    <script type="text/javascript" src="../js/gridview_setting.js"></script>
    <script type="text/javascript">

    <script type="text/javascript">
        // 设置标题
        Index.SetTitle('Excel文件管理');
        function cleartext() {

            jQuery("#txtCPDM").val("");
            jQuery("#txtCPName").val("");
            jQuery("#txtFXJG").val("");
            jQuery("#txtCPType").val("");
            jQuery("#txtLJBX").val("");
            jQuery("#txtSYL").val("");
            jQuery("#txtCPQX").val("");
            return true;
        }       
    </script>
</head>
<body>
    <div class="container">
        <form id="Form1" runat="server">
        <div class="location">
            当前位置：产品管理 -&gt; 会员产品管理</div>
        <div class="blank10">
        </div>
        <div class="search block">
            <div class="h">
                <span class="icon-sprite icon-list"></span>
                <h3>
                    上传EXCEL数据</h3>
            </div>
            <div class="tl corner">
            </div>
            <div class="tr corner">
            </div>
            <div class="bl corner">
            </div>
            <div class="br corner">
            </div>
            <div class="cnt-wp">
                <div class="cnt">
                    <div class="search-bar" style="padding-left: -3px;">
                        <table width="100%">
                            <tr>
                                <td>
                                    <asp:Label ID="Label3" Text="产品种类：" runat="server"></asp:Label>
                                    <asp:DropDownList ID="ddlCPType" runat="server">
                                        <asp:ListItem Value="银行理财产品">银行理财产品</asp:ListItem>
                                        <asp:ListItem Value="信托产品">信托产品</asp:ListItem>
                                        <asp:ListItem Value="阳光私募产品">阳光私募产品</asp:ListItem>
                                        <asp:ListItem Value="私募股权产品">私募股权产品</asp:ListItem>
                                        <asp:ListItem Value="基金产品">基金产品</asp:ListItem>
                                        <asp:ListItem Value="TOT/FOF产品">TOT/FOF产品</asp:ListItem>
                                        <asp:ListItem Value="境外理财产品">境外理财产品</asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:Label ID="Label1" Text="选择文件：" runat="server"></asp:Label>
                                    <asp:FileUpload Style="height: 20px" ID="FileUpload1" runat="server" />
                                    <span class="btn-ctl-span">
                                        <asp:Button ID="Button1" runat="server" Text="上传" OnClick="Button1_Click" /></span>
                                    <span style="color: red">*<span style="color: #000000">上传文件大小限制为 10MB</span></span>
                                </td>
                            </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        <div class="blank10">
        </div>
        <div class="search block">
            <div class="h">
                <span class="icon-sprite icon-magnifier"></span>
                <h3>
                    快速搜索</h3>
            </div>
            <div class="tl corner">
            </div>
            <div class="tr corner">
            </div>
            <div class="bl corner">
            </div>
            <div class="br corner">
            </div>
            <div class="cnt-wp">
                <div class="cnt">
                    <div class="search-bar" style="padding-left: -3px;">
                        <table width="100%">
                            <tr>
                                <td colspan="2">
                                    <asp:Label ID="Label8" Text="产品代码：" runat="server"></asp:Label>
                                    <asp:TextBox ID="txtCPDM" runat="server" CssClass="input-small" MaxLength="250"></asp:TextBox>
                                    <asp:Label ID="Label2" Text="产品名称：" runat="server"></asp:Label>
                                    <asp:TextBox ID="txtCPName" runat="server" CssClass="input-small" MaxLength="250"></asp:TextBox>
                                    <asp:Label ID="Label4" Text="发行机构：" runat="server"></asp:Label>
                                    <asp:TextBox ID="txtFXJG" runat="server" CssClass="input-small" MaxLength="250"></asp:TextBox>
                                    <asp:Label ID="Label12" Text="产品类型：" runat="server"></asp:Label>
                                    <asp:TextBox ID="txtCPType" runat="server" CssClass="input-small" MaxLength="250"></asp:TextBox>
                                </td>
                            </tr>
                            <tr style="line-height: 30px; height: 30px;">
                                <td>
                                    <asp:Label ID="Label13" Text="累计表现：" runat="server"></asp:Label>
                                    <asp:TextBox ID="txtLJBX" runat="server" CssClass="input-small" MaxLength="250"></asp:TextBox>
                                    <asp:Label ID="Label5" Text="收 益 率：" runat="server"></asp:Label>
                                    <asp:TextBox ID="txtSYL" runat="server" CssClass="input-small" MaxLength="250"></asp:TextBox>
                                    <asp:Label ID="Label14" Text="产品期限：" runat="server"></asp:Label>
                                    <asp:TextBox ID="txtCPQX" runat="server" CssClass="input-small" MaxLength="250"></asp:TextBox>
                                </td>
                                <td align="right">
                                    <span class="btn-ctl-span">
                                        <asp:Button ID="btnSearch" runat="server" Text="搜索" OnClick="btnSearch_Click" /></span>
                                    <span class="btn-ctl-span">
                                        <input type="button" id="btnClear" onclick="cleartext();" value="清空" /></span>
                                </td>
                            </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        <div class="blank10">
        </div>
        <div class="block">
            <div class="h">
                <span class="icon-sprite icon-list"></span>
                <h3>
                    Excel信息列表</h3>
                <div class="bar">
                    <asp:DropDownList ID="ddlDownLoad" runat="server">
                        <asp:ListItem Value=""></asp:ListItem>
                        <asp:ListItem Value="银行理财产品">银行理财产品</asp:ListItem>
                        <asp:ListItem Value="信托产品">信托产品</asp:ListItem>
                        <asp:ListItem Value="阳光私募产品">阳光私募产品</asp:ListItem>
                        <asp:ListItem Value="私募股权产品">私募股权产品</asp:ListItem>
                        <asp:ListItem Value="基金产品">基金产品</asp:ListItem>
                        <asp:ListItem Value="TOT/FOF产品">TOT/FOF产品</asp:ListItem>
                        <asp:ListItem Value="境外理财产品">境外理财产品</asp:ListItem>
                    </asp:DropDownList>
                    <span class="btn-ctl-span">
                        <asp:Button ID="btnSaveExcel" runat="server" Text="保存到Excel文件" OnClick="btnSaveExcel_Click" /></span>
                   <%-- <span class="btn-ctl-span">
                        <asp:Button ID="btnSubmit" runat="server" Text="删除" OnClick="btnSubmit_Click" /></span>--%>
                </div>
            </div>
            <div class="tl corner">
            </div>
            <div class="tr corner">
            </div>
            <div class="bl corner">
            </div>
            <div class="br corner">
            </div>
            <div class="cnt-wp">
                <div class="cnt">
                    <asp:GridView ID="gvExcel" runat="server" CssClass="data-table" border="0" CellPadding="0"
                        Width="100%" EnableTheming="True" AllowSorting="True" AutoGenerateColumns="False"
                        OnRowDataBound="gvExcel_RowDataBound" AllowPaging="True" OnPageIndexChanging="gvExcel_PageIndexChanging"
                        OnSorting="gvExcel_Sorting" GridLines="None" PageSize="50">
                        <Columns>
                            <asp:BoundField DataField="CUSCP_ID" SortExpression="CUSCP_ID" ItemStyle-Width="2%"
                                ItemStyle-CssClass="l" HeaderText="ID" />
                            <asp:BoundField DataField="CUSCP_CPCODE" SortExpression="CUSCP_CPCODE" ItemStyle-Width="1%"
                                ItemStyle-CssClass="l" HeaderText="产品代码" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_Name" SortExpression="CUSCP_Name" ItemStyle-Width="5%"
                                ItemStyle-CssClass="l" HeaderText="产品名称" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_Qixiri" SortExpression="CUSCP_Qixiri" ItemStyle-Width="2%"
                                ItemStyle-CssClass="l" HeaderText="起息日" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_Daoqiri" SortExpression="CUSCP_Daoqiri" ItemStyle-Width="1%"
                                ItemStyle-CssClass="l" HeaderText="到期日" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_Qixian" SortExpression="CUSCP_Qixian" ItemStyle-Width="3%"
                                ItemStyle-CssClass="l" HeaderText="产品期限" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_Shouyilv" SortExpression="CUSCP_Shouyilv" ItemStyle-Width="4%"
                                ItemStyle-CssClass="l" HeaderText="参考收益率" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_riqi" SortExpression="CUSCP_riqi" ItemStyle-Width="4%"
                                ItemStyle-CssClass="l" HeaderText="日期" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_shengoujia" SortExpression="CUSCP_shengoujia" ItemStyle-Width="2%"
                                ItemStyle-CssClass="l" HeaderText="申购价" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_shuhuijia" SortExpression="CUSCP_shuhuijia" ItemStyle-Width="2%"
                                ItemStyle-CssClass="l" HeaderText="赎回价" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_leijibiaoxian" SortExpression="CUSCP_leijibiaoxian"
                                ItemStyle-Width="2%" ItemStyle-CssClass="l" HeaderText="累计表现" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_Type" SortExpression="CUSCP_Type" ItemStyle-Width="5%"
                                ItemStyle-CssClass="l" HeaderText="产品类型" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_FXJG" SortExpression="CUSCP_FXJG" ItemStyle-Width="5%"
                                ItemStyle-CssClass="l" HeaderText="发行机构" ReadOnly="True" />
                            <asp:BoundField DataField="CUSCP_JWTZGLR" SortExpression="CUSCP_JWTZGLR" ItemStyle-Width="6%"
                                ItemStyle-CssClass="l" HeaderText="境外投资管理人" ReadOnly="True" />
                           <%-- <asp:TemplateField HeaderText="选择">
                                <ItemTemplate>
                                    <asp:CheckBox ID="chkdelete" runat="server" Checked="false" />
                                </ItemTemplate>
                                <ItemStyle Width="2%"></ItemStyle>
                            </asp:TemplateField>--%>
                        </Columns>
                    </asp:GridView>
                </div>
                <script type="text/javascript">
                var pagerUrl = 'Customer/ExcelLoad.aspx?pageIndex={0}';
                Pager.Output(pagerUrl,<%=pageSize %>, <%=pageIndex %>, <%=pageCount %>, <%=recordCount %>); //(urlFormat, pageSize, pageIndex, pageCount, recordCount)
                </script>
            </div>
        </div>
        </form>
    </div>
</body>
</html>
